A partition function is a function in the current database that maps the rows of a table or index into partitions based on the values of a specified column.
Note: Support from SQL Server 2005 or later.
Just simply click ->
Partition Function to
open an object pane for Partition Function. A control-click displays
the popup menu or using the object pane toolbar below, allowing you to create
new, edit and delete the selected partition function.
Create Partition Function
To create a new partition function
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Partition Function from the popup menu.
- Edit partition function properties on the appropriate tabs of the Partition Function Designer.
To create a new partition function with modification as one of the existing partition function
- Select the partition function for modifying in the object pane.
- Control-click and select the Design
Partition Function from the popup menu or simply double-click the partition function.
or - Click the
from the object pane toolbar.
- Modify partition function properties on the appropriate tabs of the Partition Function Designer.
- Click
Save As.
To edit the existing partition function (manage its general etc)
- Select the partition function for editing in the object pane.
- Control-click and select the Design
Partition Function from the popup menu or simply double-click the partition function.
or - Click the
from the object pane toolbar.
- Edit partition function properties on the appropriate tabs of the Partition Function Designer.
To change the name of the partition function
- Select the partition function for editing in the object pane.
- Control-click and select the Rename from the popup menu.
Delete Partition Function
To delete a partition function
- Select the partition function for deleting in the object pane.
- Control-click and select the Delete Partition Function
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Partition Function Information
To achieve a partition function information
- Select the partition function in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.